Data Analytical Processing in Data Warehouses
نویسندگان
چکیده
منابع مشابه
Query Processing Issues in Data Warehouses
Data warehouses store organizational data extracted from many operational databases. They are mainly used for decision support and OLAP applications. As a result, queries to a data warehouse have unique idiosyncrasies that have to be separately addressed. Data warehouse queries usually are much less frequent than OLTP queries and touch upon much more data than a typical OLTP query. In addition,...
متن کاملOLAP Query Processing for Partitioned Data Warehouses
On-line analytical processing (OLAP) queries can take hours or even days to execute on very large data warehouses. Therefore, there is a need to employ techniques that can facilitate efficient execution of these queries. Data partitioning concept that has been studied in the context of relational databases aims to reduce query execution time and facilitate the parallel execution of queries. In ...
متن کاملA Conceptual Model and Algebra for On-Line Analytical Processing in Data Warehouses
Data warehousing and On-Line Analytical Processing (OLAP) are two of the most signiicant new technologies in the business data processing arena. A data warehouse can be deened as a \very large" repository of historical data pertaining to an organization. OLAP refers to the technique of performing complex analysis over the information stored in a data warehouse. The complexity of queries require...
متن کاملData Quality in Data Warehouses
Fayyad and Uthursamy (2002) have stated that the majority of the work (representing months or years) in creating a data warehouse is in cleaning up duplicates and resolving other anomalies. This article provides an overview of two methods for improving quality. The first is data cleaning for finding duplicates within files or across files. The second is edit/imputation for maintaining business ...
متن کاملThe cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses
Data warehousing and On-Line Analytical Processing (OLAP) are two of the most signiicant new technologies in the business data processing arena. A data warehouse can be deened as a \very large" repository of historical data pertaining to an organization. OLAP refers to the technique of performing complex analysis over the information stored in a data warehouse. The complexity of queries require...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Foundations of Management
سال: 2010
ISSN: 2080-7279
DOI: 10.2478/v10238-012-0023-x